Overview
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 21,613 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 6 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 2.1 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 4 |
| Dataset has 6 (< 0.1%) duplicate rows | Duplicates |
bathrooms is highly overall correlated with bedrooms and 3 other fields | High correlation |
bedrooms is highly overall correlated with bathrooms and 1 other fields | High correlation |
floors is highly overall correlated with bathrooms and 1 other fields | High correlation |
grade is highly overall correlated with bathrooms and 3 other fields | High correlation |
price is highly overall correlated with grade and 1 other fields | High correlation |
sqft_living is highly overall correlated with bathrooms and 3 other fields | High correlation |
view is highly overall correlated with waterfront | High correlation |
waterfront is highly overall correlated with view | High correlation |
waterfront is highly imbalanced (93.6%) | Imbalance |
view is highly imbalanced (72.2%) | Imbalance |
yr_renovated is highly imbalanced (74.7%) | Imbalance |
Reproduction
| Analysis started | 2026-01-31 11:39:40.477637 |
|---|---|
| Analysis finished | 2026-01-31 11:39:58.313364 |
| Duration | 17.84 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
price
Real number (ℝ)
High correlation
| Distinct | 4029 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 540088.58 |
| Minimum | 75000 |
|---|---|
| Maximum | 7700000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 75000 |
|---|---|
| 5-th percentile | 210000 |
| Q1 | 321950 |
| median | 450000 |
| Q3 | 645000 |
| 95-th percentile | 1156480 |
| Maximum | 7700000 |
| Range | 7625000 |
| Interquartile range (IQR) | 323050 |
Descriptive statistics
| Standard deviation | 367126.83 |
|---|---|
| Coefficient of variation (CV) | 0.67975299 |
| Kurtosis | 34.585671 |
| Mean | 540088.58 |
| Median Absolute Deviation (MAD) | 150000 |
| Skewness | 4.0240804 |
| Sum | 1.1672934 × 1010 |
| Variance | 1.3478211 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 350000 | 172 | 0.8% |
| 450000 | 172 | 0.8% |
| 550000 | 159 | 0.7% |
| 500000 | 152 | 0.7% |
| 425000 | 150 | 0.7% |
| 325000 | 148 | 0.7% |
| 400000 | 145 | 0.7% |
| 375000 | 138 | 0.6% |
| 300000 | 133 | 0.6% |
| 525000 | 131 | 0.6% |
| Other values (4019) | 20113 |
| Value | Count | Frequency (%) |
| 75000 | 1 | |
| 78000 | 1 | |
| 80000 | 1 | |
| 81000 | 1 | |
| 82000 | 1 | |
| 82500 | 1 | |
| 83000 | 1 | |
| 84000 | 1 | |
| 85000 | 2 | |
| 86500 | 1 |
| Value | Count | Frequency (%) |
| 7700000 | 1 | |
| 7062500 | 1 | |
| 6885000 | 1 | |
| 5570000 | 1 | |
| 5350000 | 1 | |
| 5300000 | 1 | |
| 5110800 | 1 | |
| 4668000 | 1 | |
| 4500000 | 1 | |
| 4489000 | 1 |
bedrooms
Real number (ℝ)
High correlation
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3707954 |
| Minimum | 0 |
|---|---|
| Maximum | 33 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.93010515 |
|---|---|
| Coefficient of variation (CV) | 0.27593047 |
| Kurtosis | 49.054564 |
| Mean | 3.3707954 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.9740277 |
| Sum | 72853 |
| Variance | 0.8650956 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 9823 | |
| 4 | 6882 | |
| 2 | 2761 | 12.8% |
| 5 | 1601 | 7.4% |
| 6 | 272 | 1.3% |
| 1 | 199 | 0.9% |
| 7 | 38 | 0.2% |
| 0 | 13 | 0.1% |
| 8 | 13 | 0.1% |
| 9 | 6 | < 0.1% |
| Other values (3) | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 13 | 0.1% |
| 1 | 199 | 0.9% |
| 2 | 2761 | 12.8% |
| 3 | 9823 | |
| 4 | 6882 | |
| 5 | 1601 | 7.4% |
| 6 | 272 | 1.3% |
| 7 | 38 | 0.2% |
| 8 | 13 | 0.1% |
| 9 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 33 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 9 | 6 | < 0.1% |
| 8 | 13 | 0.1% |
| 7 | 38 | 0.2% |
| 6 | 272 | 1.3% |
| 5 | 1601 | 7.4% |
| 4 | 6882 | |
| 3 | 9823 |
bathrooms
Real number (ℝ)
High correlation
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1147573 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.77016316 |
|---|---|
| Coefficient of variation (CV) | 0.36418512 |
| Kurtosis | 1.2799024 |
| Mean | 2.1147573 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.51110757 |
| Sum | 45706.25 |
| Variance | 0.59315129 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.5 | 5380 | |
| 1 | 3852 | |
| 1.75 | 3048 | |
| 2.25 | 2047 | 9.5% |
| 2 | 1930 | 8.9% |
| 1.5 | 1446 | 6.7% |
| 2.75 | 1185 | 5.5% |
| 3 | 753 | 3.5% |
| 3.5 | 731 | 3.4% |
| 3.25 | 589 | 2.7% |
| Other values (20) | 652 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 0.5 | 4 | < 0.1% |
| 0.75 | 72 | 0.3% |
| 1 | 3852 | |
| 1.25 | 9 | < 0.1% |
| 1.5 | 1446 | 6.7% |
| 1.75 | 3048 | |
| 2 | 1930 | 8.9% |
| 2.25 | 2047 | 9.5% |
| 2.5 | 5380 |
| Value | Count | Frequency (%) |
| 8 | 2 | < 0.1% |
| 7.75 | 1 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 6.75 | 2 | < 0.1% |
| 6.5 | 2 | < 0.1% |
| 6.25 | 2 | < 0.1% |
| 6 | 6 | |
| 5.75 | 4 | < 0.1% |
| 5.5 | 10 | |
| 5.25 | 13 |
sqft_living
Real number (ℝ)
High correlation
| Distinct | 1038 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2079.8997 |
| Minimum | 290 |
|---|---|
| Maximum | 13540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1427 |
| median | 1910 |
| Q3 | 2550 |
| 95-th percentile | 3760 |
| Maximum | 13540 |
| Range | 13250 |
| Interquartile range (IQR) | 1123 |
Descriptive statistics
| Standard deviation | 918.4409 |
|---|---|
| Coefficient of variation (CV) | 0.44157941 |
| Kurtosis | 5.243093 |
| Mean | 2079.8997 |
| Median Absolute Deviation (MAD) | 540 |
| Skewness | 1.4715554 |
| Sum | 44952873 |
| Variance | 843533.68 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1300 | 138 | 0.6% |
| 1400 | 135 | 0.6% |
| 1440 | 133 | 0.6% |
| 1800 | 129 | 0.6% |
| 1660 | 129 | 0.6% |
| 1010 | 129 | 0.6% |
| 1820 | 128 | 0.6% |
| 1480 | 125 | 0.6% |
| 1720 | 125 | 0.6% |
| 1540 | 124 | 0.6% |
| Other values (1028) | 20318 |
| Value | Count | Frequency (%) |
| 290 | 1 | |
| 370 | 1 | |
| 380 | 1 | |
| 384 | 1 | |
| 390 | 2 | |
| 410 | 1 | |
| 420 | 2 | |
| 430 | 1 | |
| 440 | 1 | |
| 460 | 1 |
| Value | Count | Frequency (%) |
| 13540 | 1 | |
| 12050 | 1 | |
| 10040 | 1 | |
| 9890 | 1 | |
| 9640 | 1 | |
| 9200 | 1 | |
| 8670 | 1 | |
| 8020 | 1 | |
| 8010 | 1 | |
| 8000 | 1 |
sqft_lot
Real number (ℝ)
| Distinct | 9782 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15106.968 |
| Minimum | 520 |
|---|---|
| Maximum | 1651359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1800 |
| Q1 | 5040 |
| median | 7618 |
| Q3 | 10688 |
| 95-th percentile | 43339.2 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range (IQR) | 5648 |
Descriptive statistics
| Standard deviation | 41420.512 |
|---|---|
| Coefficient of variation (CV) | 2.7418151 |
| Kurtosis | 285.07782 |
| Mean | 15106.968 |
| Median Absolute Deviation (MAD) | 2618 |
| Skewness | 13.060019 |
| Sum | 3.2650689 × 108 |
| Variance | 1.7156588 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 358 | 1.7% |
| 6000 | 290 | 1.3% |
| 4000 | 251 | 1.2% |
| 7200 | 220 | 1.0% |
| 4800 | 120 | 0.6% |
| 7500 | 119 | 0.6% |
| 4500 | 114 | 0.5% |
| 8400 | 111 | 0.5% |
| 9600 | 109 | 0.5% |
| 3600 | 103 | 0.5% |
| Other values (9772) | 19818 |
| Value | Count | Frequency (%) |
| 520 | 1 | |
| 572 | 1 | |
| 600 | 1 | |
| 609 | 1 | |
| 635 | 1 | |
| 638 | 1 | |
| 649 | 2 | |
| 651 | 1 | |
| 675 | 1 | |
| 676 | 1 |
| Value | Count | Frequency (%) |
| 1651359 | 1 | |
| 1164794 | 1 | |
| 1074218 | 1 | |
| 1024068 | 1 | |
| 982998 | 1 | |
| 982278 | 1 | |
| 920423 | 1 | |
| 881654 | 1 | |
| 871200 | 2 | |
| 843309 | 1 |
floors
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.494309 |
| Minimum | 1 |
|---|---|
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5399889 |
|---|---|
| Coefficient of variation (CV) | 0.36136361 |
| Kurtosis | -0.48472294 |
| Mean | 1.494309 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.61617672 |
| Sum | 32296.5 |
| Variance | 0.29158801 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 10680 | |
| 2 | 8241 | |
| 1.5 | 1910 | 8.8% |
| 3 | 613 | 2.8% |
| 2.5 | 161 | 0.7% |
| 3.5 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 10680 | |
| 1.5 | 1910 | 8.8% |
| 2 | 8241 | |
| 2.5 | 161 | 0.7% |
| 3 | 613 | 2.8% |
| 3.5 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.5 | 8 | < 0.1% |
| 3 | 613 | 2.8% |
| 2.5 | 161 | 0.7% |
| 2 | 8241 | |
| 1.5 | 1910 | 8.8% |
| 1 | 10680 |
waterfront
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 169.0 KiB |
| 0 | |
|---|---|
| 1 | 163 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 21450 | |
| 1 | 163 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 21450 | |
| 1 | 163 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 21450 | |
| 1 | 163 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21450 | |
| 1 | 163 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21450 | |
| 1 | 163 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21450 | |
| 1 | 163 | 0.8% |
view
Categorical
High correlation Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 169.0 KiB |
| 0 | |
|---|---|
| 2 | 963 |
| 3 | 510 |
| 1 | 332 |
| 4 | 319 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 19489 | |
| 2 | 963 | 4.5% |
| 3 | 510 | 2.4% |
| 1 | 332 | 1.5% |
| 4 | 319 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 19489 | |
| 2 | 963 | 4.5% |
| 3 | 510 | 2.4% |
| 1 | 332 | 1.5% |
| 4 | 319 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 19489 | |
| 2 | 963 | 4.5% |
| 3 | 510 | 2.4% |
| 1 | 332 | 1.5% |
| 4 | 319 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19489 | |
| 2 | 963 | 4.5% |
| 3 | 510 | 2.4% |
| 1 | 332 | 1.5% |
| 4 | 319 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19489 | |
| 2 | 963 | 4.5% |
| 3 | 510 | 2.4% |
| 1 | 332 | 1.5% |
| 4 | 319 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19489 | |
| 2 | 963 | 4.5% |
| 3 | 510 | 2.4% |
| 1 | 332 | 1.5% |
| 4 | 319 | 1.5% |
condition
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 169.0 KiB |
| 3 | |
|---|---|
| 4 | |
| 5 | |
| 2 | 172 |
| 1 | 30 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 5 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 14031 | |
| 4 | 5679 | |
| 5 | 1701 | 7.9% |
| 2 | 172 | 0.8% |
| 1 | 30 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 14031 | |
| 4 | 5679 | |
| 5 | 1701 | 7.9% |
| 2 | 172 | 0.8% |
| 1 | 30 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 14031 | |
| 4 | 5679 | |
| 5 | 1701 | 7.9% |
| 2 | 172 | 0.8% |
| 1 | 30 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 14031 | |
| 4 | 5679 | |
| 5 | 1701 | 7.9% |
| 2 | 172 | 0.8% |
| 1 | 30 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 14031 | |
| 4 | 5679 | |
| 5 | 1701 | 7.9% |
| 2 | 172 | 0.8% |
| 1 | 30 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 14031 | |
| 4 | 5679 | |
| 5 | 1701 | 7.9% |
| 2 | 172 | 0.8% |
| 1 | 30 | 0.1% |
grade
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6568732 |
| Minimum | 1 |
|---|---|
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1754588 |
|---|---|
| Coefficient of variation (CV) | 0.15351681 |
| Kurtosis | 1.1909321 |
| Mean | 7.6568732 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.7711032 |
| Sum | 165488 |
| Variance | 1.3817033 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 8981 | |
| 8 | 6068 | |
| 9 | 2615 | 12.1% |
| 6 | 2038 | 9.4% |
| 10 | 1134 | 5.2% |
| 11 | 399 | 1.8% |
| 5 | 242 | 1.1% |
| 12 | 90 | 0.4% |
| 4 | 29 | 0.1% |
| 13 | 13 | 0.1% |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 29 | 0.1% |
| 5 | 242 | 1.1% |
| 6 | 2038 | 9.4% |
| 7 | 8981 | |
| 8 | 6068 | |
| 9 | 2615 | 12.1% |
| 10 | 1134 | 5.2% |
| 11 | 399 | 1.8% |
| Value | Count | Frequency (%) |
| 13 | 13 | 0.1% |
| 12 | 90 | 0.4% |
| 11 | 399 | 1.8% |
| 10 | 1134 | 5.2% |
| 9 | 2615 | 12.1% |
| 8 | 6068 | |
| 7 | 8981 | |
| 6 | 2038 | 9.4% |
| 5 | 242 | 1.1% |
| 4 | 29 | 0.1% |
yr_renovated
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 169.0 KiB |
| 0 | |
|---|---|
| 1 | 914 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 20699 | |
| 1 | 914 | 4.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 20699 | |
| 1 | 914 | 4.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20699 | |
| 1 | 914 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20699 | |
| 1 | 914 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20699 | |
| 1 | 914 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21613 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 20699 | |
| 1 | 914 | 4.2% |
lat
Real number (ℝ)
| Distinct | 5034 |
|---|---|
| Distinct (%) | 23.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.560053 |
| Minimum | 47.1559 |
|---|---|
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3103 |
| Q1 | 47.471 |
| median | 47.5718 |
| Q3 | 47.678 |
| 95-th percentile | 47.74964 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.207 |
Descriptive statistics
| Standard deviation | 0.13856371 |
|---|---|
| Coefficient of variation (CV) | 0.0029134474 |
| Kurtosis | -0.676313 |
| Mean | 47.560053 |
| Median Absolute Deviation (MAD) | 0.1049 |
| Skewness | -0.48527048 |
| Sum | 1027915.4 |
| Variance | 0.019199902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 47.6624 | 17 | 0.1% |
| 47.5322 | 17 | 0.1% |
| 47.6846 | 17 | 0.1% |
| 47.5491 | 17 | 0.1% |
| 47.6955 | 16 | 0.1% |
| 47.6886 | 16 | 0.1% |
| 47.6711 | 16 | 0.1% |
| 47.5402 | 15 | 0.1% |
| 47.6842 | 15 | 0.1% |
| 47.6904 | 15 | 0.1% |
| Other values (5024) | 21452 |
| Value | Count | Frequency (%) |
| 47.1559 | 1 | |
| 47.1593 | 1 | |
| 47.1622 | 1 | |
| 47.1647 | 1 | |
| 47.1764 | 1 | |
| 47.1775 | 1 | |
| 47.1776 | 2 | |
| 47.1795 | 1 | |
| 47.1803 | 1 | |
| 47.1808 | 1 |
| Value | Count | Frequency (%) |
| 47.7776 | 3 | |
| 47.7775 | 3 | |
| 47.7774 | 1 | < 0.1% |
| 47.7772 | 3 | |
| 47.7771 | 2 | < 0.1% |
| 47.777 | 2 | < 0.1% |
| 47.7769 | 3 | |
| 47.7768 | 2 | < 0.1% |
| 47.7767 | 6 | |
| 47.7766 | 4 |
long
Real number (ℝ)
| Distinct | 752 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.2139 |
| Minimum | -122.519 |
|---|---|
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 21613 |
| Negative (%) | 100.0% |
| Memory size | 169.0 KiB |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| median | -122.23 |
| Q3 | -122.125 |
| 95-th percentile | -121.979 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range (IQR) | 0.203 |
Descriptive statistics
| Standard deviation | 0.14082834 |
|---|---|
| Coefficient of variation (CV) | -0.0011523104 |
| Kurtosis | 1.0495009 |
| Mean | -122.2139 |
| Median Absolute Deviation (MAD) | 0.101 |
| Skewness | 0.88505298 |
| Sum | -2641408.9 |
| Variance | 0.019832622 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -122.29 | 116 | 0.5% |
| -122.3 | 111 | 0.5% |
| -122.362 | 104 | 0.5% |
| -122.291 | 100 | 0.5% |
| -122.363 | 99 | 0.5% |
| -122.372 | 99 | 0.5% |
| -122.288 | 98 | 0.5% |
| -122.357 | 96 | 0.4% |
| -122.284 | 95 | 0.4% |
| -122.365 | 94 | 0.4% |
| Other values (742) | 20601 |
| Value | Count | Frequency (%) |
| -122.519 | 1 | < 0.1% |
| -122.515 | 1 | < 0.1% |
| -122.514 | 1 | < 0.1% |
| -122.512 | 1 | < 0.1% |
| -122.511 | 2 | |
| -122.509 | 2 | |
| -122.507 | 1 | < 0.1% |
| -122.506 | 1 | < 0.1% |
| -122.505 | 3 | |
| -122.504 | 2 |
| Value | Count | Frequency (%) |
| -121.315 | 2 | |
| -121.316 | 1 | |
| -121.319 | 1 | |
| -121.321 | 1 | |
| -121.325 | 1 | |
| -121.352 | 2 | |
| -121.359 | 1 | |
| -121.364 | 2 | |
| -121.402 | 1 | |
| -121.403 | 1 |
Interactions
Correlations
| bathrooms | bedrooms | condition | floors | grade | lat | long | price | sqft_living | sqft_lot | view | waterfront | yr_renovated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bathrooms | 1.000 | 0.521 | 0.130 | 0.547 | 0.658 | 0.008 | 0.262 | 0.497 | 0.746 | 0.069 | 0.114 | 0.102 | 0.060 |
| bedrooms | 0.521 | 1.000 | 0.024 | 0.228 | 0.381 | -0.021 | 0.191 | 0.345 | 0.647 | 0.217 | 0.038 | 0.000 | 0.021 |
| condition | 0.130 | 0.024 | 1.000 | 0.179 | 0.154 | 0.058 | 0.081 | 0.023 | 0.060 | 0.039 | 0.025 | 0.017 | 0.067 |
| floors | 0.547 | 0.228 | 0.179 | 1.000 | 0.502 | 0.025 | 0.149 | 0.322 | 0.401 | -0.234 | 0.024 | 0.022 | 0.059 |
| grade | 0.658 | 0.381 | 0.154 | 0.502 | 1.000 | 0.104 | 0.223 | 0.658 | 0.716 | 0.152 | 0.143 | 0.118 | 0.013 |
| lat | 0.008 | -0.021 | 0.058 | 0.025 | 0.104 | 1.000 | -0.143 | 0.456 | 0.031 | -0.122 | 0.068 | 0.034 | 0.059 |
| long | 0.262 | 0.191 | 0.081 | 0.149 | 0.223 | -0.143 | 1.000 | 0.064 | 0.285 | 0.371 | 0.085 | 0.096 | 0.083 |
| price | 0.497 | 0.345 | 0.023 | 0.322 | 0.658 | 0.456 | 0.064 | 1.000 | 0.644 | 0.075 | 0.208 | 0.320 | 0.128 |
| sqft_living | 0.746 | 0.647 | 0.060 | 0.401 | 0.716 | 0.031 | 0.285 | 0.644 | 1.000 | 0.304 | 0.149 | 0.140 | 0.071 |
| sqft_lot | 0.069 | 0.217 | 0.039 | -0.234 | 0.152 | -0.122 | 0.371 | 0.075 | 0.304 | 1.000 | 0.040 | 0.014 | 0.000 |
| view | 0.114 | 0.038 | 0.025 | 0.024 | 0.143 | 0.068 | 0.085 | 0.208 | 0.149 | 0.040 | 1.000 | 0.592 | 0.109 |
| waterfront | 0.102 | 0.000 | 0.017 | 0.022 | 0.118 | 0.034 | 0.096 | 0.320 | 0.140 | 0.014 | 0.592 | 1.000 | 0.092 |
| yr_renovated | 0.060 | 0.021 | 0.067 | 0.059 | 0.013 | 0.059 | 0.083 | 0.128 | 0.071 | 0.000 | 0.109 | 0.092 | 1.000 |
Missing values
Sample
| price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | yr_renovated | lat | long | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 231300.0 | 2 | 1.00 | 1180 | 5650 | 1.0 | 0 | 0 | 3 | 7 | 0 | 47.5112 | -122.257 |
| 1 | 538000.0 | 3 | 2.25 | 2570 | 7242 | 2.0 | 0 | 0 | 3 | 7 | 1 | 47.7210 | -122.319 |
| 2 | 180000.0 | 2 | 1.00 | 770 | 10000 | 1.0 | 0 | 0 | 3 | 6 | 0 | 47.7379 | -122.233 |
| 3 | 604000.0 | 4 | 3.00 | 1960 | 5000 | 1.0 | 0 | 0 | 5 | 7 | 0 | 47.5208 | -122.393 |
| 4 | 510000.0 | 3 | 2.00 | 1680 | 8080 | 1.0 | 0 | 0 | 3 | 8 | 0 | 47.6168 | -122.045 |
| 5 | 1225000.0 | 4 | 4.50 | 5420 | 101930 | 1.0 | 0 | 0 | 3 | 11 | 0 | 47.6561 | -122.005 |
| 6 | 257500.0 | 3 | 2.25 | 1715 | 6819 | 2.0 | 0 | 0 | 3 | 7 | 0 | 47.3097 | -122.327 |
| 7 | 291850.0 | 3 | 1.50 | 1060 | 9711 | 1.0 | 0 | 0 | 3 | 7 | 0 | 47.4095 | -122.315 |
| 8 | 229500.0 | 3 | 1.00 | 1780 | 7470 | 1.0 | 0 | 0 | 3 | 7 | 0 | 47.5123 | -122.337 |
| 9 | 323000.0 | 3 | 2.50 | 1890 | 6560 | 2.0 | 0 | 0 | 3 | 7 | 0 | 47.3684 | -122.031 |
| price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | yr_renovated | lat | long | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21603 | 507250.0 | 3 | 2.50 | 2270 | 5536 | 2.0 | 0 | 0 | 3 | 8 | 0 | 47.5389 | -121.881 |
| 21604 | 429000.0 | 3 | 2.00 | 1490 | 1126 | 3.0 | 0 | 0 | 3 | 8 | 0 | 47.5699 | -122.288 |
| 21605 | 610685.0 | 4 | 2.50 | 2520 | 6023 | 2.0 | 0 | 0 | 3 | 9 | 0 | 47.5137 | -122.167 |
| 21606 | 1007500.0 | 4 | 3.50 | 3510 | 7200 | 2.0 | 0 | 0 | 3 | 9 | 0 | 47.5537 | -122.398 |
| 21607 | 475000.0 | 3 | 2.50 | 1310 | 1294 | 2.0 | 0 | 0 | 3 | 8 | 0 | 47.5773 | -122.409 |
| 21608 | 360000.0 | 3 | 2.50 | 1530 | 1131 | 3.0 | 0 | 0 | 3 | 8 | 0 | 47.6993 | -122.346 |
| 21609 | 400000.0 | 4 | 2.50 | 2310 | 5813 | 2.0 | 0 | 0 | 3 | 8 | 0 | 47.5107 | -122.362 |
| 21610 | 402101.0 | 2 | 0.75 | 1020 | 1350 | 2.0 | 0 | 0 | 3 | 7 | 0 | 47.5944 | -122.299 |
| 21611 | 400000.0 | 3 | 2.50 | 1600 | 2388 | 2.0 | 0 | 0 | 3 | 8 | 0 | 47.5345 | -122.069 |
| 21612 | 325000.0 | 2 | 0.75 | 1020 | 1076 | 2.0 | 0 | 0 | 3 | 7 | 0 | 47.5941 | -122.299 |
Duplicate rows
Most frequently occurring
| price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | yr_renovated | lat | long | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 259950.0 | 2 | 2.00 | 1070 | 649 | 2.0 | 0 | 0 | 3 | 9 | 0 | 47.5213 | -122.357 | 2 |
| 1 | 529500.0 | 3 | 2.25 | 1410 | 905 | 3.0 | 0 | 0 | 3 | 9 | 0 | 47.5818 | -122.402 | 2 |
| 2 | 550000.0 | 4 | 1.75 | 2410 | 8447 | 2.0 | 0 | 3 | 4 | 8 | 1 | 47.6499 | -122.088 | 2 |
| 3 | 555000.0 | 3 | 2.50 | 1940 | 3211 | 2.0 | 0 | 0 | 3 | 8 | 0 | 47.5644 | -122.093 | 2 |
| 4 | 585000.0 | 3 | 2.50 | 2290 | 5089 | 2.0 | 0 | 0 | 3 | 9 | 0 | 47.5443 | -122.172 | 2 |
| 5 | 635000.0 | 3 | 3.00 | 2230 | 1407 | 2.5 | 0 | 0 | 3 | 8 | 0 | 47.5446 | -122.017 | 2 |